go

create PROCEDURE [dbo].[ConsultarSalonPractica]( @idSalon INT )
AS
BEGIN
    SET NOCOUNT ON;
    SELECT s.id_salon,s.tipo,s.nombre,s.edificio,s.capacidad,s.status
    FROM salon s
    WHERE id_salon = @idSalon and status = 1;
END